package com.itc.bi.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.itc.bi.entity.BigScreenPageEntity;
import com.itc.bi.vo.bigScreenVO.DownTreeListVO;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
* @author hecai
* @description 针对表【big_screen_page(态势模板)】的数据库操作Mapper
* @createDate 2024-06-20 14:11:51
* @Entity com.itc.bi.BigScreenPage
*/
public interface BigScreenPageMapper extends BaseMapper<BigScreenPageEntity> {

    @Select(" SELECT " +
            " A.p_id, " +
            " A.id,b.id as bigScreenId, " +
            " A.NAME AS typeName, " +
            " b.NAME AS bigScreenName, " +
            " b.code  " +
            "FROM " +
            " big_screen_type AS A  " +
            " LEFT JOIN big_screen_page AS b ON A.code = b.parent_code ")
    List<DownTreeListVO> getDownTreeList();
}




